package com.gimi.cloud.bbp.dao.dao.mall;

import java.util.List;

import org.apache.ibatis.annotations.Select;

import com.gimi.cloud.bbp.dao.dao.sys.BaseDao;
import com.gimi.cloud.bbp.dao.myMapper.MyMapper;
import com.gimi.cloud.bbp.dto.mall.MallAppBannerDTO;
import com.gimi.cloud.bbp.entity.mall.MallAppBannerEntity;

/**
 * Banner 信息
 *
 * @author wbj
 * @version 1.0
 * @Description
 * @create 2018-01-30
 **/
public interface MallAppBannerDao extends MyMapper<MallAppBannerEntity>,BaseDao<MallAppBannerEntity,MallAppBannerDTO> {
	
	@Select("SELECT * FROM `mall_app_banner` WHERE brp_status = 1 AND is_delete = 0 AND abg_id = #{abgId} ORDER BY brp_sort ASC")
	List<MallAppBannerDTO> getBannerByAbgId(Integer abgId);
}
